package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.annotation.DataSource;
import com.ruoyi.common.enums.DataSourceType;
import com.ruoyi.system.domain.OtherBlocketRecord;
import com.ruoyi.system.domain.OtherGiftReceptionRecord;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.List;

@DataSource(value = DataSourceType.SLAVE)
public interface OtherGiftReceptionRecordMapper extends BaseMapper<OtherGiftReceptionRecord> {

    @Select("select * from GiftReceptionRecord where roomID=  #{roomId} and DATE(createTime) BETWEEN #{startDate} AND #{endDate}  AND TIME(createTime) BETWEEN #{startTime} AND #{endTime} ")
    public List<OtherGiftReceptionRecord> getGiftReceptionRecord(@Param("roomId") String roomID, @Param("startDate") String startDate, @Param("endDate")String endDate, @Param("startTime")String startTime, @Param("endTime")String endTime);


}
